Tabela Employer

Definicja tabeli Employer

Name

Employer

Code

Employer

Comment

 


Lista kolumn tabeli Employer

Name

Code

EmployerID

EmployerID

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

TaxPayerID

TaxPayerID

CompanyStatisticalNo

CompanyStatisticalNo

Active

Active

IdentificationNo

IdentificationNo

IdentificationTypeId

IdentificationTypeId

FirstName

FirstName

LastName

LastName

DownloadedFromZUS

DownloadedFromZUS

Secret

Secret

IsPUE

IsPUE

NationalIDNo

NationalIDNo


Kolumna EmployerID tabeli Employer

Definicja kolumny EmployerID tabeli Employer

Name

EmployerID

Code

EmployerID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Code tabeli Employer

Definicja kolumny Code tabeli Employer

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli Employer

Definicja kolumny ShortName tabeli Employer

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli Employer

Definicja kolumny FullName tabeli Employer

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli Employer

Definicja kolumny Description tabeli Employer

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna TaxPayerID tabeli Employer

Definicja kolumny TaxPayerID tabeli Employer

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna CompanyStatisticalNo tabeli Employer

Definicja kolumny CompanyStatisticalNo tabeli Employer

Name

CompanyStatisticalNo

Code

CompanyStatisticalNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna Active tabeli Employer

Definicja kolumny Active tabeli Employer

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna IdentificationNo tabeli Employer

Definicja kolumny IdentificationNo tabeli Employer

Name

IdentificationNo

Code

IdentificationNo

Data Type

VARCHAR2(30)

Mandatory

No

Comment

numer identyfikacyjny pesel/dowAld/nr paszportu


Kolumna IdentificationTypeId tabeli Employer

Definicja kolumny IdentificationTypeId tabeli Employer

Name

IdentificationTypeId

Code

IdentificationTypeId

Data Type

NUMBER(10)

Mandatory

No

Comment

typ numeru identyfikacyjnego 1-nip/2-pesel/3-paszport/4-regon/5-dowod


Kolumna FirstName tabeli Employer

Definicja kolumny FirstName tabeli Employer

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Imie


Kolumna LastName tabeli Employer

Definicja kolumny LastName tabeli Employer

Name

LastName

Code

LastName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Nazwisko


Kolumna DownloadedFromZUS tabeli Employer

Definicja kolumny DownloadedFromZUS tabeli Employer

Name

DownloadedFromZUS

Code

DownloadedFromZUS

Data Type

NUMBER(3)

Mandatory

No

Comment

pobrany z ZUS


Kolumna Secret tabeli Employer

Definicja kolumny Secret tabeli Employer

Name

Secret

Code

Secret

Data Type

NUMBER(3)

Mandatory

No

Comment

platnik wrazliwy


Kolumna IsPUE tabeli Employer

Definicja kolumny IsPUE tabeli Employer

Name

IsPUE

Code

IsPUE

Data Type

NUMBER(3)

Mandatory

No

Comment

czy platnik ma konto w ZUS


Kolumna NationalIDNo tabeli Employer

Definicja kolumny NationalIDNo tabeli Employer

Name

NationalIDNo

Code

NationalIDNo

Data Type

VARCHAR2(24)

Mandatory

No

Comment

Pesel


Lista kluczy tabeli Employer

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Employer

Definicja klucza Identifier_1 tabeli Employer

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment